Re: SERIAL Field - Mailing list pgsql-admin

From Joel Stevenson
Subject Re: SERIAL Field
Date
Msg-id a0511170cb8fc9c4efa8b@[192.168.1.100]
Whole thread Raw
In response to Re: SERIAL Field  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
>
>People who have not studied the documentation frequently make that
>claim.  *There is no such risk* (unless A and B are interleaving their
>commands on a single database connection, in which case they have lots
>worse risks of conflicts than this one).  See
>http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/functions-sequence.html
>
>            regards, tom lane

Point taken.  I've worked on web-apps which use a single JDBC
connection per user session where the overlap could occur, but as you
say there are far greater issues involved for such session-based
connections.
--
Joel Stevenson
Bear River Associates, Inc.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: SERIAL Field
Next
From: "otisg"
Date:
Subject: Re: Dying PostgreSQL backend